package com.company.project.dao;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.company.project.core.Mapper;
import com.company.project.model.VO.FilterVO;
import com.company.project.model.VO.StatisticsDetailDO;
import com.company.project.model.VO.ZhusuVO;
import com.company.project.model.VtZhusu;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface VtZhusuMapper extends Mapper<VtZhusu> {

//    @Select("SELECT * FROM `vt_zhusu` WHERE scdate BETWEEN #{startTime} and #{endTime} AND groupid = #{groupId} AND isdel = 0 ORDER BY scdate DESC\n")

    List<VtZhusu> findListByGroupId(@Param("groupId") Integer groupId);
    List<VtZhusu> findTodayListByGroupId(@Param("startTime") long startTime, @Param("endTime")long endTime, @Param("groupId") Integer groupId, @Param("isExamine") Integer isExamine);

    List<VtZhusu> findHistoryListByGroupId(@Param("startTime") long startTime, @Param("groupId") Integer groupId, @Param("isExamine") Integer isExamine);

    List<VtZhusu> findTodayAllList(@Param("isExamine") Integer isExamine);

    List<VtZhusu> findHistoryAllList(FilterVO filterVO);

    Integer getOperatorCount(@Param("startTime") long startTime, @Param("endTime")long endTime,@Param("groupId") Integer groupId,@Param("classes") Integer classes);

    List<StatisticsDetailDO> getStatisticsDetail(@Param("startTime") long startTime, @Param("endTime")long endTime, @Param("groupId") Integer groupId, @Param("classes") Integer classes);

}